select * from products where pro_name like '%quinceanera%bra%' or pro_des like '%quinceanera%bra%'union all select * from products where (pro_name like '%quinceanera%' or pro_des like '%quinceanera%') or(pro_name like '%bra%' or pro_des like '%bra%') and (pro_name not like '%quinceanera%bra%' or pro_des not like '%quinceanera%bra%')
Purple Dress For Quinceaneras by Satin with Strapless neck and Embroidery
Teal and White Organza Quince Dress with Strapless Neck and Appliques
Paris Fashion Week Yellow and Green Dress For Quince with Beaded Bodice and Ruffled Skirt
Cheap Coral Red Sweetheart Quinceanera Dress with Appliques and Layers
Brown Tulle and Taffeta Quinceanera Dress in Floor-length with Beading
Cheap White and Purple Sweetheart Quinceanera by Organza with Appliques
Blue Organza Sweet Sixteen Quinceanera Dresses with Beading and Ruches
Purple Taffeta Quinceanera Gown with Sweetheart Neck and Matching Jacket
Purple Quinceanera Gown by Organza with Strapless Neck and Appliques
Apple Green Quinceanera Gown Dress by Taffeta and Organza with Ruffles
Purple Organza Quinceanera Gown Dress with Appliques and Pick-ups
Green Sweet Sixteen Quinceanera Dresses with Sweetheart Neck and Ruffles
Hot Pink Sweetheart Quince Dress by Organza with Embroidery and Beading
Yellow Green Dress For Quinceaneras with White Appliques and Ruffles
Hunter Green Organza Quinceanera Dress with Boning Details and Ruffles for Miss Freedom Of The World
Taffeta Quinceanera Gown with Strapless Neck and Appliques
Multi-Color Sweetheart Quinceanera Gowns with Appliques and Ruffles
Dark Green Quince Gown with Bodice by sequined Fabric and Ruffled Skirt
Yellow Quinceanera Dress by Taffeta and Organza with Beading and Ruffles
Yellow Green Organza Quinceanera Dress with Sweetheart Neck and Beading
2014 Purple Sweet Sixteen Quinceanera Dresses with Beading and Ruffles
Teal Taffeta Quinceanera Gown with Sweetheart Neckline and Appliques
Apple Green Quinceanera Dress by Taffeta with Beading and Pick-ups
Spring Green Strapless Quinceanera Gown dress by Organza with Pick-ups
Aqua Blue Sweetheart Quinceanera Gown Dress by Sequined Fabric for 2013
Strapless Sweet Sixteen Dresses by Organza with Appliques
Lavender Tulle Quince Dress with Ruched Bodice and A-Line / Princess Skirt
Strapless Sweet Sixteen Dresses by Tulle with Appliques
Spring Green Sweetheart Quinceanera Gowns with Ruches and Ruffled Skirt
Green and Pink One Shoulder Quince Dress with Beading and Ruffles